import numpy as py
import pandas as pd
import os
df=pd.read_excel('第4分店产品销售表.xlsx')
df1=pd.DataFrame
groups=df.groupby('单价（元）')
for group in groups:
    df_temp=pd.DataFrame(group[1])
    df_temp.fillna(method='bfill',inplace=True)









